PlEmployer 
Logical Entity Name  PlEmployer 
Default Table Name  PlEmployer 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

PlEmployer Columns 
ColumnName  Domain  Datatype  NULL  Definition 
PlEmployerID(PK)    int  NO 
 
Descrip    varchar(40)  NO 
 
Code    char(16)  NO 
 
Addr1    varchar(255)  NO 
 
City    varchar(35)  NO 
 
State    char(2)  NO 
 
Zip    char(10)  NO 
 
SyCountyID    int  YES 
 
Phone    char(16)  NO 
 
email    varchar(60)  YES 
 
EmployerType    char(1)  YES 
 
SyCampusGrpID    int  NO 
 
PlCorporateID    int  YES 
 
PlIndustryID    int  YES 
 
Fee    char(1)  YES 
 
FeeDescrip    varchar(50)  YES 
 
Comments    text  YES 
 
Active    bit  NO 
 
UserID    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
ExternType    char(1)  YES 
 
PIN    smallint  YES 
 
Fax    char(16)  NO 
 
URL    char(100)  YES 
 
PhoneExt    char(5)  YES 
 
SyCountryID    int  YES 
 
SyStaffID(FK)    int  YES 
 
Validated    bit  NO 
 
PLAdvisorID(FK)    int  YES 
 
PracticumSite    bit  NO 
 
CrmSuppressFlag    bit  NO 
 
PrimaryPlEmployerLocationID(FK)    int  YES 
 
SyNexusOrganizationId(FK)    int  YES 
 

PlEmployer Primary and Unique Keys 
Key Name  Key Type  Keys 
PlEmployer_Code_U_N_IDX  Index  Code 
PlEmployer_PlEmployerID_U_C_IDX  PrimaryKey  PlEmployerID 
PlEmployer_plEmployerId_email_U_N_IDX  Index  PlEmployerID, email 

PlEmployer Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_PlEmployer.PLAdvisorID_SyStaff.SyStaffID      PLAdvisorID  NO  YES 
SyNexusOrganization  Non-Identifying  Zero or One to Zero or More  FK_PlEmployer_SyNexusOrganizationId_SyNexusOrganization_SyNexusOrganizationId      SyNexusOrganizationId  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_PlEmployer_SyStaffID_SyStaff_SyStaffID      SyStaffID  NO  YES 
PlLocation  Non-Identifying  Zero or One to Zero or More  FK_PlEmployerPrimaryPlEmployerLocationID_PlLocationPlLocationID      PrimaryPlEmployerLocationID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
PlEmployerCareerField  Identifying  One To Zero or More  FK_PLEmployerCareerField_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
PlEmployerContact  Non-Identifying  One To Zero or More  FK_PlEmployerContact_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
PlEmployerContactAttribute  Non-Identifying  One To Zero or More  FK_PlEmployerContactAttribute.PlEmployerID_PlEmployer.PlEmployerID        NO  YES 
PlEmployerContactJobSkill  Identifying  One To Zero or More  FK_PlEmployerContactJobSkill_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
PlEmployerContactSoftSkill  Identifying  One To Zero or More  FK_PlEmployerContactSoftSkill_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
plEmployerExternalMap  Non-Identifying  One To Zero or More  FK_plEmployerExternalMapplEmployerId_plEmployerplEmployerId        NO  YES 
PlEmployerJob  Non-Identifying  One To Zero or More  FK_PlEmployerJob_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
PlEmployerJobSkill  Non-Identifying  One To Zero or More  FK_PlEmployerJobSkill_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
PlEmployerLocation  Non-Identifying  One To Zero or More  FK_PlEmployerLocation_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
PlEmployerSoftSkill  Identifying  One To Zero or More  FK_PlEmployerSoftSkill_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
PlStudentContactHistory  Non-Identifying  One To Zero or More  FK_PlStudentContactHistoryId_PlEmployerId_PlEmployer_PlEmployerId        NO  YES 
PlStudentPlacement  Non-Identifying  One To Zero or More  FK_PlStudentPlacement_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
SyEmpGrp  Non-Identifying  One To Zero or More  FK_SyEmpGrp_PlEmployerId_PlEmployer_PlEmployerId        NO  YES 
SyRecentEmployer  Non-Identifying  One To Zero or More  FK_SyRecentEmployer_PlEmployerID_PlEmployer_PlEmployerID        NO  YES 
SyStudentNI  Non-Identifying  One To Zero or More  FK_SyStudentNI_CPTEmployerID_PlEmployer_PlEmployerID        NO  YES 
SyStudentNI  Non-Identifying  One To Zero or More  FK_SyStudentNI_OPTEmployerID_PlEmployer_PlEmployerID        NO  YES 

PlEmployer Check Constraints 
Check Constraint Name  CheckConstraint 

PlEmployer Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group  PRIMARY 

PlEmployer Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.Employer 
NO       
Physical (Microsoft SQL Server)
dbo.PlEmployer 
NO       

PlEmployer Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  AvailableJobs 
Logical  Employers 
Logical  SEVIS 
Logical  StudentJobPlacement 
Logical  Tasks 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Placement 

PlEmployer Data Movement Rules 
Name  Type  Rule Text/Value